Database Programming

MGS3001 Python Programming for Business, Spring 2025

Chungil Chae

Wed, 26 February 2025

Learning Objectives

This chapter introduces the student to database programming. The chapter first introduces the basic concepts of databases, such as tables, rows, and primary keys. Then the student learns to use SQLite to connect to a database in Python. SQL is introduced and the student learns to execute queries and statements that search for rows, add new rows, update existing rows, and delete rows. CRUD applications are demonstrated, and the chapter concludes with a discussion of relational data.

SHORT VIDEO INTRODUCTION

#

##

House management

Assignment

What to do

Requirement
- PDF format
- file name should be include your student id and name
  - stuID_name_title.pdf (e.g. 1111111_ChungilChae_SelfIntroduction.pdf)
Due date
- by Feb23(Sun) 11:59PM
- NO LATE SUBMISSION ALLOWED!!!!

Database Programming

Learning Objectives

SHORT VIDEO INTRODUCTION

#

##

House management

Assignment

Reference